Learn Excel from MrExcel - Episode 184 - Straight Line Estimate
One of the simplest ways of forecasting is to assume that the sales are increasing along a straight trendline. Excel offers a function to calculate a trendline, but it is one of the most bizarre functions. If you don't know the secret to using LINEST, it will try and describe a line with a single value, like "208". This is enough to confuse even the rocket scientists. Let MrExcel show you the simple (but non-intuitive) steps to entering an array formula. Episode 184 will show you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!